# -*- coding:utf-8 -*-
# !/usr/bin/env python
# 作者: xsc
# 创建: 2020-07-01
# 更新: 2020-07-01
# 用意: 常量类
import configparser
import datetime
import os


class _const:
    
    class ConstError(TypeError):
        pass

    class ConstCaseError(ConstError):
        pass

    def __setattr__(self, name, value):
        if name in self.__dict__:
            raise self.ConstError("can't change const %s" % name)
        if not name.isupper():
            raise self.ConstCaseError('const name "%s" is not all uppercase' % name)
        self.__dict__[name] = value


# 读取配置文件对象
cf = configparser.ConfigParser()
cf.read("./conf/deal.conf")
const = _const()

# MYSQL数据库信息
const.MYSQL_HOST = cf.get('mysql', 'mysql_host')
const.MYSQL_PORT = cf.get('mysql', 'mysql_port')
const.MYSQL_USER = cf.get('mysql', 'mysql_user')
const.MYSQL_PWD = cf.get('mysql', 'mysql_pwd')
# const.MYSQL_DB = cf.get('mysql', 'mysql_db')
const.MYSQL_CHARSET = cf.get('mysql', 'mysql_charset')

# 获取当前文件父级路径
const.CURRENT_PATH = os.getcwd()

# 本地程序运行log日志存放路径
const.LOG_PATH = const.CURRENT_PATH + '/log/'
if not os.path.exists(const.LOG_PATH):
    os.makedirs(const.LOG_PATH)


const.SITEDATA = const.CURRENT_PATH + '/sqlData/'
if not os.path.exists(const.SITEDATA):
    os.makedirs(const.SITEDATA)

# # 1号线LC数据文件保存路径
# const.WLCONE = const.CURRENT_PATH + '/alysisFile/lc/1/'
# if not os.path.exists(const.WLCONE):
#     os.makedirs(const.WLCONE)
# # 2号线LC数据文件保存路径
# const.WLCTWO = const.CURRENT_PATH + '/alysisFile/lc/2/'
# if not os.path.exists(const.WLCTWO):
#     os.makedirs(const.WLCTWO)
# # 3号线LC数据文件保存路径
# const.WLCTHREE = const.CURRENT_PATH + '/alysisFile/lc/3/'
# if not os.path.exists(const.WLCTHREE):
#     os.makedirs(const.WLCTHREE)
# # 4号线LC数据文件保存路径
# const.WLCFOUR = const.CURRENT_PATH + '/alysisFile/lc/4/'
# if not os.path.exists(const.WLCFOUR):
#     os.makedirs(const.WLCFOUR)
# # 5号线LC数据文件保存路径
# const.WLCFIVE = const.CURRENT_PATH + '/alysisFile/lc/5/'
# if not os.path.exists(const.WLCFIVE):
#     os.makedirs(const.WLCFIVE)
# # 6号线LC数据文件保存路径
# const.WLCSIX = const.CURRENT_PATH + '/alysisFile/lc/6/'
# if not os.path.exists(const.WLCSIX):
#     os.makedirs(const.WLCSIX)
#
#
# # 1号线SC数据文件保存路径
# const.WSCONE = const.CURRENT_PATH + '/alysisFile/sc/1/'
# if not os.path.exists(const.WSCONE):
#     os.makedirs(const.WSCONE)
# # 2号线SC数据文件保存路径
# const.WSCTWO = const.CURRENT_PATH + '/alysisFile/sc/2/'
# if not os.path.exists(const.WSCTWO):
#     os.makedirs(const.WSCTWO)
# # 3号线SC数据文件保存路径
# const.WSCTHREE = const.CURRENT_PATH + '/alysisFile/sc/3/'
# if not os.path.exists(const.WSCTHREE):
#     os.makedirs(const.WSCTHREE)
# # 4号线SC数据文件保存路径
# const.WSCFOUR = const.CURRENT_PATH + '/alysisFile/sc/4/'
# if not os.path.exists(const.WSCFOUR):
#     os.makedirs(const.WSCFOUR)
# # 5号线SC数据文件保存路径
# const.WSCFIVE = const.CURRENT_PATH + '/alysisFile/sc/5/'
# if not os.path.exists(const.WSCFIVE):
#     os.makedirs(const.WSCFIVE)
# # 6号线SC数据文件保存路径
# const.WSCSIX = const.CURRENT_PATH + '/alysisFile/sc/6/'
# if not os.path.exists(const.WSCSIX):
#     os.makedirs(const.WSCSIX)

const.SQL0103 =  "INSERT INTO txncardissue (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipmentl_number, samid, udsn, serviceparticipantid, location_type, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, expirydate, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" 

const.SQL0303 =  "INSERT INTO txnproductmultirideissue (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, pplicationpersonalisecat, appActionSequenceNumber, applicationtype, applicationpassengertype, productissuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, numrides, remainingrides, transactionvalue, paymentmethod, partialtransactionvalue, vstartdatetime, venddatetime, vduration, location_type2, spare2, lineid2, stationid2, location_type3, spare3, lineid3, stationid3, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0302 =  "INSERT INTO txnproductpassissue (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productissuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, numrides, remainingrides, transactionvalue, paymentmethod, partialtransactionvalue, vstartdatetime, venddatetime, vduration, vorigin, vdestination, location_type2, spare2, lineid2, stationid2, location_type3, spare3, lineid3, stationid3, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0301 =  "INSERT INTO txnproductpurseissue (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardIssuerid, cardserialnumber, cardtype, cardLifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productIssuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, purseremainingvalue, transactionvalue, paymentmethod, partialtransactionvalue, vstartdatetime, venddatetime, vduration, location_type2, spare2, lineid2, stationid2, location_type3, spare3, lineid3, stationid3, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0379 =  "INSERT INTO txnproductmultirideexitticketissue (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productIssuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, numrides, remainingrides, transactionvalue, paymentmethod, partialtransactionvalue, vstartdatetime, venddatetime, vduration, location_type2, spare2, lineid2, station2, location_type3, spare3, lineid3, stationid3, invalidcardserialnumber, invalidproductissuer, invalidlifecyclecount, invalidproducttype, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL030C =  "INSERT INTO txnproductmultirideadd (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, spare, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productissuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, numrides, remainingrides, transactionvalue, paymentmethod, partialtransactionvalue, vstartdatetime, venddatetime, vduration, location_type2, spare2, lineid2, stationid2, location_type3, spare3, lineid3, stationid3, lavsamid, lavparticipantid, lavdate, lavtxnvalue, lavremainingrides, lavptsn, lavmethodofpayment, dataIsvalid, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL030B =  "INSERT INTO txnproductpassadd (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txnDateTime, sourceParticipantId, equipment_type, lineid, stationid, samId, udsn, serviceParticipantId, location_type1, spare1, lineid1, stationid1, transactionStatus, cdVersion, reconciliationDate, reservedField, udType, udSubtype, cardIssuerId, cardSerialNumber, cardType, cardLifeCycleCount, cardActionSequenceNumber, applicationProviderId, applicationSerialNumber, applicationPersonaliseCat, appActionSequenceNumber, applicationType, applicationPassengerType, productIssuerId, productSerialNumber, productType, productActionSequenceNumber, ptsn, invoiceprinted1, passEndDateTime, transactionValue, paymentMethod, partialTransactionValue, vStartDateTime, vEndDateTime, vDuration, location_type2, spare2, lineid2, stationid2, location_type3, spare3, lineid3, stationid3, lavSamId, lavParticipantId, lavDate, lavTxnValue, lavRemainingRides, lavPtsn, lavMethodOfPayment, dataIsValid, invoiceprinted, txnMac, keyVersion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL030A =  "INSERT INTO txnproductpurseadd (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productIssuerid, productserialnumber, producttype, productactionSequencenumber, ptsn, invoiceprinted1, passenddatetime, transactionvalue, paymentmethod, partialtransactionvalue, vstartdatetime, venddatetime, vduration, location_type2, spare2, lineid2, stationid2, location_type3, spare3, lineid3, stationid3, lavsamid, lavparticipantid, lavdate, lavtxnvalue, lavremainingrides, lavptsn, lavmethodofpayment, dataIsvalid, invoiceprinted, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0378 =  "INSERT INTO txnproductmultiridecompensationfare (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid1, stationid1, equipment_serial_number, samid, udsn, serviceparticipantid, location_type2, spare2, lineid2, stationid2, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productIssuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, passengertype, currentlocation, triporiginlocation, trippreviouslocation, numrides, remainingrides, transactionvalue, paymentmethod, compensationreason, vstartdatetime, venddatetime, vduration, location_type4, spare4, lineid4, stationid4, location_type5, spare5, lineid5, stationid5, vorigin, vdestination, lavsamid, lavparticipantid, lavdate, lavtxnvalue, lavremainingrides, lavptsn, lavmethodofpayment, dataIsvalid, invoiceprinted1, txnmac, keyversion, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0377 =  "INSERT INTO txnproductpasscompensationfare (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid1, stationid1, station_serial_number, samid, udsn, serviceparticipantid, location_type2, spare2, lineid2, stationid2, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productissuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, passengertype, currentlocation, triporiginlocation, trippreviouslocation, passenddatetime, transactionvalue, paymentmethod, compensationreason, vstartdatetime, venddatetime, vduration, location_type3, spare3, lineid3, stationid3, location_type4, spare4, lineid4, stationid4, vorigin, vdestination, lavsamid, lavparticipantid, lavdate, lavtxnvalue, lavpassexpirydatetime, lavptsn, lavmethodofpayment, dataIsvalid, invoiceprinted1, txnmac, keyversion, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0376 =  "INSERT INTO txnproductpursecompensationfare (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationDate, reservedfeld, udtype, udsubtype, cardIssuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productIssuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, passengertype, currentlocation, triporiginlocation, trippreviouslocation, purseremainingvalue, transactionvalue, paymentmethod, compensationreason, lavsamid, lavparticipantid, lavdate, lavtxnvalue, lavremainingvalue, lavptsn, lavmethodofpayment, dataIsvalid, invoiceprinted1, txnmac, keyversion, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0109 =  "INSERT INTO txncarddepositreceipt (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardlssuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionaequencenumber, transactionvalue, paymentmethod, partialtransactionvalue, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0422 =  "INSERT INTO txncardholderfee (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardIssuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, cardholderserialnum, cardholderIssuerid, companyid, classificationLevel, transactionvalue, paymentmethod, partialtransactionvalue, feetype, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0116 =  "INSERT INTO txncardfee (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardIssuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, transactionvalue, paymentmethod, partialtransactionvalue, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL010A =  "INSERT INTO txncardrefund (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardIssuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, cardholderserialnum, cardholderissuerid, companyid, classificationlevel, transactionvalue, paymentmethod, partialtransactionvalue, receiptnumber, refundreason, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL031C =  "INSERT INTO txnproductmultiriderefund (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, cardholderserialnum, cardholderissuerid, companyid, classificationlevel, applicationproviderid, applicationserialnumber, applicationproviderId1, appactionsequencenumber, applicationtype, applicationpassengertype, productissuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, numrides, remainingrides, transactionvalue, paymentmethod, partialtransactionvalue, lavsamid, lavparticipantid, lavdate, lavtxnvalue, lavremainingrides, lavptsn, lavmethodofpayment, dataIsvalid, invoiceprinted1, refundreason, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL031B =  "INSERT INTO txnproductpassrefund (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txnDateTime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, cardholderserialnum, cardholderissuerid, companyid, classificationlevel, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productissuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, passenddatetime, transactionvalue, paymentmethod, partialtransactionvalue, lavsamid, lavparticipantid, lavdate, lavtxnvalue, lavpassexpirydatetime, lavptsn, lavmethodofpayment, dataIsvalid, invoiceprinted1, refundreason, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL031A =  "INSERT INTO txnproductpurserefund (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardLifecyclecount, cardsactionsequencenumber, cardholderserialnum, cardholderissuerid, companyid, classificationlevel, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productissuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, purseremainingvalue, transactionvalue, paymentmethod, partialtransactionvalue, lavsamid, lavparticipantid, lavdate, lavtxnvalue, lavremainingvalue, lavptsn, lavmethodofpayment, dataIsvalid, invoiceprinted1, refundreason, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0127 =  "INSERT INTO txncarddepositreceiptrefund (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardLifecyclecount, cardsactionsequencenumber, transactionvalue, paymentmethod, partialtransactionvalue, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL034F =  "INSERT INTO txnproductmultirideissuereverse (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardIssuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productIssuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, numrides, remainingrides, paymentmethod, partialtransactionvalue, vstartdatetime, venddatetime, vduration, location_type2, spare2, lineid2, stationid2, location_type3, spare3, lineid3, stationid3, reversedudsn, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0350 =  "INSERT INTO txnproductpassissuereverse (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txnDateTime, sourceParticipantId, equipment_type, lineid, stationid, equipment_serial_number, samId, udsn, serviceParticipantId, location_type1, spare1, lineid1, stationid1, transactionStatus, cdVersion, reconciliationDate, reservedField, udType, udSubtype, cardIssuerId, cardSerialNumber, cardType, cardLifeCycleCount, cardActionSequenceNumber, applicationProviderId, applicationSerialNumber, applicationPersonaliseCat, appActionSequenceNumber, applicationType, applicationPassengerType, productIssuerId, productSerialNumber, productType, productActionSequenceNumber, ptsn, invoiceprinted, passEndDateTime, paymentMethod, partialTransactionValue, vStartDateTime, vEndDateTime, vDuration, location_type2, spare2, lineid2, stationid2, location_type3, spare3, lineid3, stationid3, reversedUdsn, txnMac, keyVersion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0351 =  "INSERT INTO txnproductpurseissuereverse (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productIssuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, purseremainingvalue, transactionvalue, paymentmethod, partialtransactionvalue, vstartdatetime, venddatetime, vduration, location_type2, spare2, lineid2, stationid2, location_type3, spare3, lineid3, stationid3, reversedudsn, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0312 =  "INSERT INTO txnproductmultirideaddreverse (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, samid, equipment_serial_number, udsn, serviceparticipantid, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationpassengertype, productissuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, numrides, remainingrides, transactionvalue, paymentmethod, partialtransactionvalue, vstartdatetime, venddatetime, vduration, location_type2, spare2, lineid2, stationid2, location_type3, spare3, lineid3, stationid3, lavsamid, lavparticipantid, lavdate, lavtxnvalue, lavremainingrides, lavptsn, lavmethodofpayment, dataIsvalid, invoiceprinted1, staffId, reversalreason, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0311 =  "INSERT INTO txnproductpassaddreverse (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txnDateTime, sourceParticipantId, equipment_type, lineid, stationid, equipment_serial_number, samId, udsn, serviceParticipantId, location_type1, spare1, lineid1, stationid1, transactionStatus, cdVersion, reconciliationDate, reservedField, udType, udSubtype, cardIssuerId, cardSerialNumber, cardType, cardLifeCycleCount, cardActionSequenceNumber, applicationProviderId, applicationSerialNumber, applicationPersonaliseCat, appActionSequenceNumber, applicationType, applicationPassengerType, productIssuerId, productSerialNumber, productType, productActionSequenceNumber, ptsn, invoiceprinted, passEndDateTime, transactionValue, paymentMethod, partialTransactionValue, vStartDateTime, vEndDateTime, vDuration, vOrigin, vDestination, lavSamId, lavParticipantId, lavDate, lavTxnValue, lavPassExpiryDateTime, lavPtsn, lavMethodOfPayment, dataIsValid, invoicePrinted1, staffId, reversalReason, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0310 =  "INSERT INTO txnproductpurseaddreverse (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipment_type, lineid, stationid, equipment_serial_number, samid, udsn, serviceparticipantid, location_type1, spare1, lineid1, station1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardissuerid, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, applicationproviderid, applicationserialnumber, applicationpersonalisecat, appactionsequencenumber, applicationtype, applicationPassengertype, productIssuerid, productserialnumber, producttype, productactionsequencenumber, ptsn, invoiceprinted, purseremainingvalue, transactionvalue, paymentmethod, partialtransactionvalue, lavsamid, lavparticipantid, lavdate, lavtxnvalue, lavremainingvalue, lavptsn, lavmethodofpayment, dataIsvalid, invoiceprinted1, staffid, reversalreason, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0120 =  "INSERT INTO txncarddepositreceiptreverse (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantId, equipment_type, lineid, stationid, equipment_serial_number, samId, udsn, serviceparticipantId, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardIssuerId, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, transactionvalue, paymentmethod, partialtransactionvalue, reverseudsn, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0121 =  "INSERT INTO txncardfeereverse (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantId, equipment_type, lineid, stationid, equipment_serial_number, samId, udsn, serviceparticipantId, location_type1, spare1, lineid1, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, cardIssuerId, cardserialnumber, cardtype, cardlifecyclecount, cardactionsequencenumber, transactionvalue, paymentmethod, partialtransactionvalue, reverseudsn, txnmac, keyversion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"


const.SQL2401 = ""
const.SQL2402 = ""
const.SQL2403 = ""
#const.SQL2401 =  "INSERT INTO qr_code_electronic_ticket_inbound_trading (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipmenttype, lineid, stationid, station_equipment_number, samid, udsn, serviceparticipantid, station_location_code_equipment, location_type, linid, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, productissuerid, producttype, modulecode, terminaltime, stationcode, pattern, equipmentnumber, equipmenttype1, equipment_serial_number, device_offline_status, terminalordernumber, operator_code, scan_time_qr_code, record_generationtime, transaction_type, userid, usercardnumber, usercardtype, small_userid, code_station_to_added, time_being_boarded_out_station, supplementary_registration_event_number, channel) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

#const.SQL2402 =  "INSERT INTO qr_code_electronic_ticket_outbound_trading (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipmenttype, lineid, stationid, station_equipment_number, samid, udsn, serviceparticipantid, station_location_code_equipment, location_type, linid, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, productissuerid, producttype, modulecode, terminaltime, stationcode, pattern, equipmentnumber, equipmenttype1, equipment_serial_number, device_offline_status, terminalordernumber, operator_code, scan_time_qr_code, record_generationtime, transaction_type, userid, usercardnumber, usercardtype, small_userid, code_station_to_added, time_being_boarded_out_station, supplementary_registration_event_number, channel) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

#const.SQL2403 =  "INSERT INTO qr_code_electronic_ticket_replacement_transaction (data_source, operator_id, occurrence_date, data_length, reserve1, formatversion, txndatetime, sourceparticipantid, equipmenttype, lineid, stationid, station_equipment_number, samid, udsn, serviceparticipantid, station_location_code_equipment, location_type, linid, stationid1, transactionstatus, cdversion, reconciliationdate, reservedfield, udtype, udsubtype, productissuerid, producttype, modulecode, terminaltime, stationcode, pattern, equipmentnumber, equipmenttype1, equipment_serial_number, device_offline_status, terminalordernumber, operator_code, scan_time_qr_code, record_generationtime, transaction_type, userid, usercardnumber, usercardtype, small_userid, code_station_to_added, time_being_boarded_out_station, supplementary_registration_event_number, channel) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL5001 =  "INSERT INTO bomtotvm_failure_refund_transaction (data_source, operator_id, occurrence_date, data_length, reserve1, equipment_type, line_number, station_number, equipment_number, afc_data_serial_number, transaction_generation_time, data_type, data_subtype, equipment_type1, line_number1, station_number1, equipment_number1, failure_time, afc_serial_number_fault_equipment, bom_refund_amount) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL5101 =  "INSERT INTO tvm_failure_refund (`data_source`, `operator_id`, `occurrence_date`, `location_type`, `location_id`, `equipment_type`, `line_number`, `station_number`, `equipment_number`, `afc_data_serial_number`, `business_data_generation_time`, `data_type`, `data_subtype`, `data_length`, `reserve`, `equipment_type1`, `line_number1`, `station_number1`, `equipment_number1`, `failure_date`, `afc_data_serial_number1`, `transaction_number`, `refund_amout`, `fault_cause`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL5006 =  "INSERT INTO recovery_of_sold_tickets (data_source, operator_id, occurrence_date, data_length, reserve1, equipment_type, line_number, station_number, equipment_number, afc_data_serial_number, transaction_generation_time, data_type, data_subtype, card_issuer_id, ticket_product_type, card_serial_number, card_life_cycle_original_transaction, transaction_serial_number_original_transaction, original_transaction_amount, transaction_type_original_transaction, transaction_subtype_original_transaction) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL5002 =  "INSERT INTO non_immediate_refund_application_transaction (data_source, operator_id, occurrence_date, data_length, reserve1, equipment_type, line_number, station_number, equipment_number, afc_data_serial_number, transaction_generation_time, data_type, data_subtype, card_issuer, ticket_card_type, card_serial_number, ticket_product_type, nameofcardholder, cardholder_phone_number, card_holder_certificate_type, identification_number, deposit, card_balance, reason_type_return_card, card_return_receipt_number, return_date) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL5003 =  "INSERT INTO ticket_free_inboundandoutbound_transactions (data_source, operator_id, occurrence_date, data_length, reserve1, equipment_type, line_number, station_number, equipment_number, afc_data_serial_number, transaction_generation_time, data_type, data_subtype, typesofbusiness) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
                     
const.SQL5004 =  "INSERT INTO tcm_using_transactions (data_source, operator_id, occurrence_date, data_length, reserve1, equipment_type, line_number, station_number, equipment_number, afc_data_serial_number, transaction_generation_time, data_type, data_subtype, emqusagetype) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL5005 =  "INSERT INTO invalid_ticket_recycling_transaction (data_source, operator_id, occurrence_date, data_length, reserve1, equipment_type, line_number, station_number, equipment_number, afc_data_serial_number, transaction_generation_time, data_type, data_subtype, card_serial_number, card_physical_type, card_issuers, ticket_product_type, causesofwaste_cards, line_number1, ticket_box_type, ticket_box_number) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0C21 =  "INSERT INTO txnykt_no_online_transactions (data_source, operator_id, occurrence_date, data_length, reserve1, udsubtype, udtype, localtxnseq, posid, samId, samseq, equipmenttype, lineid, station_number, station_equipment_number, posoperid, citycode, cardid, cardcsn, crddebitcnt, cardmodel, crdmKnd, crdsknd, befbalance, txnamt, usertype, origamt, txndate, txntime, tac, crdverno, aftbalance, line_operators_generate_transactions_id, generate_trading_station_number, entry_station_no, arrival_time, last_station_id, ticket_validity, occurrence_time_delayed_transaction, originalstationid_delayed_transaction, business_model_causing_delayed_trading) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0E08 =  "INSERT INTO txnykt_recharge (data_source, operator_id, occurrence_date, data_length, reserve1, udsubtype, udtype, localtxnseq, samId, posid, samseq, equipmenttype, lineid, station_number, station_equipment_number, posoperid, citycode, cardid, cardcsn, crddebitcnt, cardmodel, crdmKnd, crdsknd, TransType, befbalance, txnamt, deposit, aftbalance, saledate, salemode, cardvaldate, txndate, txntime, crdverno, batchno, serial_key_authorization, quota_authorization_serial_number, last_transaction_type, last_transaction_terminal_number, amount_last_transaction, last_transaction_card_counter, last_transaction_time, amount_before_last_transaction, tac_last_transaction, transaction_authentication_code_tac, lineid_operators_generate_transactions, generate_trading_station_number) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0F08 =  "INSERT INTO txnykt_compensationfare (data_source, operator_id, occurrence_date, data_length, reserve1, udsubtype, udtype, localtxnseq, posid, samId, samseq, equipmenttype, lineid, station_number, station_equipment_number, posoperid, citycode, cardid, cardcsn, crddebitcnt, cardmodel, crdmKnd, crdsknd, befbalance, txnamt, usertype, origamt, txndate, txntime, tac, crdverno, aftbalance, line_operator_generated_transaction_id, generate_trading_station_number, entry_station_no, entry_station_time, previous_station_id, ticket_validity, original_occurrence_time_delayed_transaction, original_stationid_delayed_transaction, business_model_causing_delayed_trading) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0C22 =  "INSERT INTO trafficcard_localcard_nononline_transaction (data_source, operator_id, occurrence_date, data_length, reserve1, udsubtype, udtype, localtxnseq, posid, samId, samseq, equipmenttype, lineid, station_number, station_equipment_number, posoperid, cardid, cardcsn, crddebitcnt, cardmodel,productsub, producttyp,befbalance, txnamt, usertype, origamt, txndate, txntime, tac, crdverno, aftbalance, line_operators_generate_transactions_id, generate_trading_station_number, entry_station_no, arrival_time, last_station_id, ticket_validity, occurrence_time_delayed_transaction, originalstationid_delayed_transaction, business_model_causing_delayed_trading, card_issuing_institution_code, merchant_identifier, merchant_type, citycode, supplementary_ticket_type, pay_method, reserve2) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0C23 =  "INSERT INTO nononline_transaction_trafficcard_remotecard (data_source, operator_id, occurrence_date, data_length, reserve1, udsubtype, udtype, localtxnseq, posid, samId, samseq, equipmenttype, lineid, station_number, station_equipment_number, posoperid, cardid, cardcsn, crddebitcnt, cardmodel,productsub, producttyp, befbalance, txnamt, usertype, origamt, txndate, txntime, tac, crdverno, aftbalance, line_operators_generate_transactions_id, generate_trading_station_number, entry_station_no, arrival_time, last_station_id, ticket_validity, occurrence_time_delayed_transaction, originalstationid_delayed_transaction, business_model_causing_delayed_trading, card_issuing_institution_code, merchant_identifier, merchant_type, interworking_citycode, consumer_keyversion, consumer_keyindex, algorithm_identification, supplementary_tickettype, paymethod, reserve2) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL5109 =  "INSERT INTO cash_box_replacement (data_source, operator_id, occurrence_date, location_type, location_id, equipment_type, line_number, station_number, equipment_number, afc_data_serial_number, business_data_generation_time, data_type, data_subtype, data_length, reserve, change_operation_type, money_box_id, cash_box_location_id, replacement_results, number_coins_box, coins_number) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL5115 =  "INSERT INTO cash_box_counting (data_source, operator_id, occurrence_date, location_type, location_id, equipment_type, line_number, station_number, equipment_number, afc_data_serial_number, business_data_generation_time, data_type, data_subtype, data_length, reserve, operation_type, cash_boxid, equipment_type1, line_number1, station_number1, equipment_number1, total_number_coins_box, number_coins_before_replacement, number_coins_after_replacement) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0375 = "INSERT INTO TxnProductDelayPurseUseOnExit (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txnDateTime, sourceParticipantId, equipment_type, line_number, station_number, equipment_number, samId, udsn, serviceParticipantId, location_type1, unknown1, line_number1, station_number1, transactionStatus, cdVersion, reconciliationDate, reservedField, udType, udSubtype, cardIssuerId, cardSerialNumber, cardType, cardLifeCycleCount, cardActionSequenceNumber, applicationProviderId, applicationSerialNumber, applicationPersonaliseCat, appActionSequenceNumber, applicationType, applicationPassengerType, passengerType, location_type2, unknown2, line_number2, station_number2, location_type3, unknown3, line_number3, station_number3, location_type4, unknown4, line_number4, station_number4, productIssuerId, productSerialNumber, productType, productActionSequenceNumber, Ptsn, invoicePrinted, purseRemainingValue, transactionValue, paymentMethod, partialTransactionValue, lavSamId, lavParticipantId, lavDate, lavTxnValue, lavRemainingValue, lavPtsn, lavMethodOfPayment, dataIsValid, invoicePrintedt, entryTime, totalJourneyAmount, endOfJourney, delayDate, delayStationLocation, delayOperationMode, firstUseActivation, txnMac, keyVersion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0373 = "INSERT INTO TxnProductDelayPassUseOnExit (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txnDateTime, sourceParticipantId, equipment_type, line_number, station_number, equipment_number, samId, udsn, serviceParticipantId, location_type1, unknown1, line_number1, station_number1, transactionStatus, cdVersion, reconciliationDate, reservedField, udType, udSubtype, cardIssuerId, cardSerialNumber, cardType, cardLifeCycleCount, cardActionSequenceNumber, applicationProviderId, applicationSerialNumber, applicationPersonaliseCat, appActionSequenceNumber, applicationType, applicationPassengerType, passengerType, location_type2, unknown2, line_number2, station_number2, location_type3, unknown3, line_number3, station_number3, location_type4, unknown4, line_number4, station_number4, productIssuerId, productSerialNumber, productType, productActionSequenceNumber, Ptsn, invoicePrinted, passEndDateTime, vStartDateTime, vEndDateTime, vDuration, location_type5, unknown5, line_number5, station_number5, location_type6, unknown6, line_number6, station_number6, lavSamId, lavParticipantId, lavDate, lavTxnValue, lavPassExpiryDateTime, lavPtsn, lavMethodOfPayment, dataIsValid, invoicePrintedt, entryTime, endOfJourney, delayDate, delayStationLocation, delayOperationMode, firstUseActivation, txnMac, keyVersion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL0371 = "INSERT INTO TxnProductDelayMultirideUseOnExit (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txnDateTime, sourceParticipantId, equipment_type, line_number, station_number, equipment_number, samId, udsn, serviceParticipantId, location_type1, unknown1, line_number1, station_number1, transactionStatus, cdVersion, reconciliationDate, reservedField, udType, udSubtype, cardIssuerId, cardSerialNumber, cardType, cardLifeCycleCount, cardActionSequenceNumber, applicationProviderId, applicationSerialNumber, applicationPersonaliseCat, appActionSequenceNumber, applicationType, applicationPassengerType, productIssuerId, productSerialNumber, productType, productActionSequenceNumber, Ptsn, invoicePrinted, passengerType, location_type2, unknown2, line_number2, station_number2, location_type3, unknown3, line_number3, station_number3, location_type4, unknown4, line_number4, station_number4, numRides, remainingRides, vStartDateTime, vEndDateTime, vDuration, location_type5, unknown5, line_number5, station_number5, location_type6, unknown6, line_number6, station_number6, lavSamId, lavParticipantId, lavDate, lavTxnValue, lavRemainingRides, lavPtsn, lavMethodOfPayment, dataIsValid, invoicePrintedt, entryTime, endOfJourney, delayDate, delayStationLocation, delayOperationMode, valuePerRide, firstUseActivation, txnMac, keyVersion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# TxnProductPurseUseOnExit
const.SQL035B = "INSERT INTO TxnProductPurseUseOnExit (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txnDateTime, sourceParticipantId, equipment_type, line_number, station_number, equipment_number, samId, udsn, serviceParticipantId, location_type1, unknown1, line_number1, station_number1, transactionStatus, cdVersion, reconciliationDate, reservedField, udType, udSubtype, cardIssuerId, cardSerialNumber, cardType, cardLifeCycleCount, cardActionSequenceNumber, applicationProviderId, applicationSerialNumber, applicationPersonaliseCat, appActionSequenceNumber, applicationType, applicationPassengerType, productIssuerId, productSerialNumber, productType, productActionSequenceNumber, Ptsn, invoicePrinted, passengerType, location_type2, unknown2, line_number2, station_number2, location_type3, unknown3, line_number3, station_number3, location_type4, unknown4, line_number4, station_number4, purseRemainingValue, transactionValue, paymentMethod, partialTransactionValue, lavSamId, lavParticipantId, lavDate, lavTxnValue, lavRemainingValue, lavPtsn, lavMethodOfPayment, dataIsValid, invoicePrintedt, entryTime, cardCaptured, totalJourneyAmount, endOfJourney, firstUseActivation, txnMac, keyVersion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# TxnProductPassUseOnExit
const.SQL035C = "INSERT INTO TxnProductPassUseOnExit (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txnDateTime, sourceParticipantId, equipment_type, line_number, station_number, equipment_number, samId, udsn, serviceParticipantId, location_type1, unknown1, line_number1, station_number1, transactionStatus, cdVersion, reconciliationDate, reservedField, udType, udSubtype, cardIssuerId, cardSerialNumber, cardType, cardLifeCycleCount, cardActionSequenceNumber, applicationProviderId, applicationSerialNumber, applicationPersonaliseCat, appActionSequenceNumber, applicationType, applicationPassengerType, productIssuerId, productSerialNumber, productType, productActionSequenceNumber, Ptsn, invoicePrinted, passengerType, location_type2, unknown2, line_number2, station_number2, location_type3, unknown3, line_number3, station_number3, location_type4, unknown4, line_number4, station_number4, passEndDateTime, vStartDateTime, vEndDateTime, vDuration, location_type5, unknown5, line_number5, station_number5, location_type6, unknown6, line_number6, station_number6, lavSamId, lavParticipantId, lavDate, lavTxnValue, lavPassExpiryDateTime, lavPtsn, lavMethodOfPayment, dataIsValid, invoicePrintedt, entryTime, endOfJourney, firstUseActivation, txnMac, keyVersion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# TxnProductMultirideUseOnExit
const.SQL035D = "INSERT INTO TxnProductMultirideUseOnExit (data_source, operator_id, occurrence_date, data_length, reserve1, formatVersion, txnDateTime, sourceParticipantId, equipment_type, line_number, station_number, equipment_number, samId, udsn, serviceParticipantId, location_type1, unknown1, line_number1, station_number1, transactionStatus, cdVersion, reconciliationDate, reservedField, udType, udSubtype, cardIssuerId, cardSerialNumber, cardType, cardLifeCycleCount, cardActionSequenceNumber, applicationProviderId, applicationSerialNumber, applicationPersonaliseCat, appActionSequenceNumber, applicationType, applicationPassengerType, productIssuerId, productSerialNumber, productType, productActionSequenceNumber, Ptsn, invoicePrinted, passengerType, location_type2, unknown2, line_number2, station_number2, location_type3, unknown3, line_number3, station_number3, location_type4, unknown4, line_number4, station_number4, numRides, remainingRides, vStartDateTime, vEndDateTime, vDuration, location_type5, unknown5, line_number5, station_number5, location_type6, unknown6, line_number6, station_number6, lavSamId, lavParticipantId, lavDate, lavTxnValue, lavRemainingRides, lavPtsn, lavMethodOfPayment, dataIsValid, invoicePrintedt, entryTime, cardCaptured, endOfJourney, valuePerRide, firstUseActivation, txnMac, keyVersion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL7004 = "INSERT INTO tvmonef (data_source, equipment_type, line_number, station_number, equipment_number, refund_serial_number, refund_time, Refund_amount) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)"

const.SQL7005 = "INSERT INTO bomonef (data_source, equipment_type, line_number, station_number, equipment_number, requipment_type, rline_number, rstation_number, requipment_number, refund_serial_number, operator_id, refund_time, Refund_amount) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# 钱箱更换
const.SQL0981 = "INSERT INTO cash_drawer_replacement (data_source, replacement_time, equipment_type, line_number, station_number, equipment_number, operator_id, operation_object, operation_type, cash_box_id, replacement_status, operation_amount, reserved) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# acc对账接口文件
const.DZTABLELIST = [{'filetype': 'F101', 'tablelist': ('ReconciliationScopeData_ypt',)},
                {'filetype': 'F201', 'tablelist': ('ReconciliationScopeData_ykt',)},
                {'filetype': 'F301', 'tablelist': ('ReconciliationScopeData_jtk',)},
                {'filetype': 'F401', 'tablelist': ('ReconciliationScopeData_ydjtk',)},
                {'filetype': 'F102', 'tablelist': ('ReconciliationErrorDetail_ypt',)},
                {'filetype': 'F202', 'tablelist': ('ReconciliationErrorDetail_ykt',)},
                {'filetype': 'F302', 'tablelist': ('ReconciliationErrorDetail_jtk',)},
                {'filetype': 'F402', 'tablelist': ('ReconciliationErrorDetail_ydjtk',)},
                {'filetype': 'F103', 'tablelist': ('ReconciliationAdjustDetail_ypt',)},
                {'filetype': 'F203', 'tablelist': ('ReconciliationAdjustDetail_ykt',)},
                {'filetype': 'F303', 'tablelist': ('ReconciliationAdjustDetail_jtk',)},
                {'filetype': 'F403', 'tablelist': ('ReconciliationAdjustDetail_ydjtk',)},
                {'filetype': 'F104', 'tablelist': ('ReconciliationStatData_ypt',)},
                {'filetype': 'F204', 'tablelist': ('ReconciliationStatData_ykt',)},
                {'filetype': 'F304', 'tablelist': ('ReconciliationStatData_jtk',)},
                {'filetype': 'F404', 'tablelist': ('ReconciliationStatData_ydjtk',)},
                {'filetype': 'F105', 'tablelist': ('ReconciliationQrTicketError',)},
                {'filetype': 'F106', 'tablelist': ('ReconciliationCleanData',)},
                {'filetype': 'F107', 'tablelist': ('ReconciliationCashIncome',)}]

# ReconciliationScopeData
const.SQLF101 = "INSERT INTO ReconciliationScopeData_ypt (data_source, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, settle_state ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF201 = "INSERT INTO ReconciliationScopeData_ykt (data_source, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, settle_state ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF301 = "INSERT INTO ReconciliationScopeData_jtk (data_source, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, settle_state ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF401 = "INSERT INTO ReconciliationScopeData_ydjtk (data_source, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, settle_state ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)"

# ReconciliationErrorDetail
const.SQLF102 = "INSERT INTO ReconciliationErrorDetail_ypt (data_source, settle_seq, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, recorder, TxnType, TxnSubType, TxnSeq, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnDate, TxnTime, PosId, SamSeq, CrdMKnd, CrdSKnd, CardModel, CardId, CardCsn, CrdDebitCnt, BefBalance, TxnAmt, CrdDpt, AftBalance, TAC, RefuseRsn ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF202 = "INSERT INTO ReconciliationErrorDetail_ykt (data_source, settle_seq, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, recorder, TxnType, TxnSubType, TxnSeq, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnDate, TxnTime, PosId, SamSeq, CrdMKnd, CrdSKnd, CardModel, CardId, CardCsn, CrdDebitCnt, BefBalance, TxnAmt, CrdDpt, AftBalance, TAC, RefuseRsn ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF302 = "INSERT INTO ReconciliationErrorDetail_jtk (data_source, settle_seq, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, recorder, TxnType, TxnSubType, TxnSeq, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnDate, TxnTime, PosId, SamSeq, CrdMKnd, CrdSKnd, CardModel, CardId, CardCsn, CrdDebitCnt, BefBalance, TxnAmt, CrdDpt, AftBalance, TAC, RefuseRsn ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF402 = "INSERT INTO ReconciliationErrorDetail_ydjtk (data_source, settle_seq, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, recorder, TxnType, TxnSubType, TxnSeq, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnDate, TxnTime, PosId, SamSeq, CrdMKnd, CrdSKnd, CardModel, CardId, CardCsn, CrdDebitCnt, BefBalance, TxnAmt, CrdDpt, AftBalance, TAC, RefuseRsn ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# ReconciliationAdjustDetail
const.SQLF103 = "INSERT INTO ReconciliationAdjustDetail_ypt (data_source, settle_date, settle_seq, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, recorder, TxnSeq, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnType, TxnSubType, TxnDate, TxnTime, CardId, CrdDebitCnt, TxnAmt, CrdDpt, AdjFlag ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF203 = "INSERT INTO ReconciliationAdjustDetail_ykt (data_source, settle_date, settle_seq, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, recorder, TxnSeq, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnType, TxnSubType, TxnDate, TxnTime, CardId, CrdDebitCnt, TxnAmt, CrdDpt, AdjFlag ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF303 = "INSERT INTO ReconciliationAdjustDetail_jtk (data_source, settle_date, settle_seq, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, recorder, TxnSeq, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnType, TxnSubType, TxnDate, TxnTime, CardId, CrdDebitCnt, TxnAmt, CrdDpt, AdjFlag ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF403 = "INSERT INTO ReconciliationAdjustDetail_ydjtk (data_source, settle_date, settle_seq, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, recorder, TxnSeq, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnType, TxnSubType, TxnDate, TxnTime, CardId, CrdDebitCnt, TxnAmt, CrdDpt, AdjFlag ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# ReconciliationStatData
const.SQLF104 = "INSERT INTO ReconciliationStatData_ypt (data_source, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnType, TxnSubType, TxnNum, TxnDeposit, TxnAmt, TxnErrNum, TxnErrDeposit, TxnErrAmt, TxnAdjNum, TxnAdjDeposit, TxnAdjAmt) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF204 = "INSERT INTO ReconciliationStatData_ykt (data_source, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnType, TxnSubType, TxnNum, TxnDeposit, TxnAmt, TxnErrNum, TxnErrDeposit, TxnErrAmt, TxnAdjNum, TxnAdjDeposit, TxnAdjAmt) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF304 = "INSERT INTO ReconciliationStatData_jtk (data_source, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnType, TxnSubType, TxnNum, TxnDeposit, TxnAmt, TxnErrNum, TxnErrDeposit, TxnErrAmt, TxnAdjNum, TxnAdjDeposit, TxnAdjAmt) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
const.SQLF404 = "INSERT INTO ReconciliationStatData_ydjtk (data_source, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnType, TxnSubType, TxnNum, TxnDeposit, TxnAmt, TxnErrNum, TxnErrDeposit, TxnErrAmt, TxnAdjNum, TxnAdjDeposit, TxnAdjAmt) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# ReconciliationQrTicketError
const.SQLF105 = "INSERT INTO ReconciliationQrTicketError (data_source, settle_seq, package_type, equipment_type, line_number, station_number, equipment_number, package_time, package_seq, recorder, TxnType, TxnSubType, TxnSeq, TermId_equipment_type, TermId_line_number, TermId_station_number, TermId_equipment_number, TxnDate, TxnTime, TerminalOrder, RefuseRsn ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# ReconciliationCleanData
const.SQLF106 = "INSERT INTO ReconciliationCleanData (data_source, settle_date, OperStat_date, line_OperationID, line_number, InStation_number, OutStation_number, ticket_issuer, ticket_type, TxnType, TxnState, TxnNum, TxnAmt, CleanAmt, CleanNum, CleanType) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# ReconciliationCashIncome
const.SQLF107 = "INSERT INTO ReconciliationCashIncome (data_source, settle_date, line_OperationID, station_number, equipment_number, ticket_issuer, ticket_type, TxnType, TxnState, PaymentType, TxnNum, UnitTxnAmt, TxnAmt, TxnTimes) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"

# 9号线BOM票房结算数据
const.SQL4012 = "INSERT INTO BOMSettleData (data_source, equipment_number, settle_seq, settle_date, settle_time_begin, settle_time_end, settle_operator, stat_date, productType, productSubType, TxnType, TxnSubType, TxnNum, DebitAmt, TxnAmt, CommissionAmt, CostAmt, PaymentType, reserve1, reserve2, reserve3, reserve4, reserve5, reserve6) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
